package com.kcyu.sfherp.mapper.ms;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kcyu.sfherp.entity.OrderDetail;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrderDetailMapper extends BaseMapper<OrderDetail> {

    @Select("SELECT TOP 1000 *, (sl * (jg - jj)) as ml FROM orchmx WHERE dh LIKE '%${dh}%'")
    List<OrderDetail> getDetail(@Param("dh") String dh);

}
